package com.wanbangee.marksystem.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.wanbangee.marksystem.entities.UTeacher;

@Mapper
public interface UTeacherDao {

	public Integer addTeacher(UTeacher teacher);
	
	public Integer selectAccIdByTeaId(Integer teaId);
	
	public Integer updateTeacherStateByTeaId(Integer teaId);
	
	public Integer updateTeacher(UTeacher teacher);
	
	public UTeacher selectTeacherByTeaId(Integer teaId);
	
	public List<UTeacher> selectTeacherBySchId(Integer schId,Integer pageNum,Integer pageSize);
	
	public List<UTeacher> selectTeacherBySchIdAndSubId(Integer schId,Integer subId,Integer pageNum,Integer pageSize);
	
	public UTeacher  selectTeacherByaccId(Integer accId);
	
	public Integer selectCountTeacherBySchId(Integer schId);
	
	public List<UTeacher> selctTeacherByTeaNmAndSchId(String teaNm,Integer schId);
	
	
}